use talent_operation;
/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80014
 Source Host           : localhost:3306
 Source Schema         : lu_cloud_stack

 Target Server Type    : MySQL
 Target Server Version : 80014
 File Encoding         : 65001

 Date: 13/02/2023 16:36:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lu_article
-- ----------------------------
DROP TABLE IF EXISTS `lu_article`;
CREATE TABLE `lu_article` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `update_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `header_pid` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL COMMENT '作者id',
  `title` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `author` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '作者',
  `auth_level` smallint(4) DEFAULT NULL COMMENT '授权等级',
  `points` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '积分',
  `views` int(11) DEFAULT NULL COMMENT '浏览量',
  `thumbs_up` int(11) DEFAULT NULL COMMENT '点赞数',
  `status` smallint(6) DEFAULT NULL COMMENT '-1保存草稿;0等待审核;1审核通过',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章列表';

-- ----------------------------
-- Records of lu_article
-- ----------------------------
BEGIN;
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (96, '2019-07-31 13:07:58.0', '2019-12-22 18:18:46.129', 14, NULL, 'Idea实用插件1', '111', 1, '0', 5, NULL, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (97, '2019-08-01 09:45:22.0', '2019-12-24 10:06:41.998', 14, NULL, 'Arthas 基础篇1', '666', 1, '0', 4, 1, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (98, '2019-08-14 09:08:47.963', '2019-08-15 00:07:04.529', 20, NULL, '优秀的sql', 'ShowLu', 1, '0', NULL, NULL, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (101, '2019-08-27 09:23:55.102', '2019-08-27 09:23:55.102', 23, NULL, 'Kafka 分区多线程', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (102, '2019-08-27 09:23:55.169', '2019-08-27 09:23:55.169', 23, NULL, 'Java ThreadPoolExecutor线程池概述', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (103, '2019-08-27 09:23:55.174', '2019-08-27 09:23:55.174', 23, NULL, 'easyui combo 用法', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (104, '2019-08-27 09:23:55.177', '2019-08-27 09:23:55.177', 23, NULL, 'oracle优秀的sql', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (105, '2019-08-27 09:23:55.181', '2019-08-27 09:23:55.181', 23, NULL, '3D学习', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (106, '2019-08-27 09:23:55.186', '2019-08-27 09:23:55.186', 23, NULL, '尚硅谷最新全套视频、资料、源码下载地址', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (107, '2019-08-27 09:23:55.192', '2019-08-27 09:23:55.192', 23, NULL, 'crentos7 下定时脚本，crontab', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (108, '2019-08-27 09:23:55.195', '2019-08-27 09:23:55.195', 23, NULL, 'Elasticsearch 集群学习', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (109, '2019-08-27 09:23:55.2', '2019-08-27 09:23:55.2', 23, NULL, '在mac上使用aria2', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (110, '2019-08-27 09:23:55.203', '2019-08-27 09:23:55.203', 23, NULL, 'Mac 必备工具之 brew', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (111, '2019-08-27 09:23:55.207', '2019-08-27 09:23:55.207', 23, NULL, 'Centos7 安装Redis', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (112, '2019-08-27 09:23:55.211', '2019-08-27 09:23:55.211', 23, NULL, 'layui 更改table中超出范围的字段显示问题', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (113, '2019-08-27 09:23:55.218', '2019-08-27 09:23:55.218', 23, NULL, 'centos7 安装最新版postgresql10', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (114, '2019-08-27 09:23:55.221', '2019-08-27 09:23:55.221', 23, NULL, 'ElasticSearch之CURL操作', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (115, '2019-08-27 09:23:55.224', '2019-08-27 09:23:55.224', 23, NULL, 'Elasticsearch Java API 的使用 --- 分组聚合', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (116, '2019-08-27 09:23:55.229', '2019-08-27 09:23:55.229', 23, NULL, 'Java Http 请求的那些问题 ', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (117, '2019-08-27 09:23:55.235', '2019-08-27 09:23:55.235', 23, NULL, '树莓派的新手入门', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (118, '2019-08-27 09:23:55.238', '2019-08-27 09:23:55.238', 23, NULL, 'freemark 生成 doc、html等文件', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (119, '2019-08-27 09:23:55.242', '2019-08-27 09:23:55.242', 23, NULL, 'Linux下Centos7对外开放端口', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (120, '2019-08-27 09:23:55.248', '2019-08-27 09:23:55.248', 23, NULL, 'MySQL一张表 设置 多个字段属性timestamp 问题', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (121, '2019-08-27 09:23:55.252', '2019-08-27 09:23:55.252', 23, NULL, '使用Sigar获取服务器内存、IP、CPU、IO、MAC地址、操作系统等信息', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (122, '2019-08-27 09:23:55.256', '2019-08-27 09:23:55.256', 23, NULL, '发布者订阅者模式与生产者消费者模式', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (123, '2019-08-27 09:23:55.261', '2019-08-27 09:23:55.261', 23, NULL, 'Centos7 安装 GateOne', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (124, '2019-08-27 09:23:55.266', '2019-08-27 09:23:55.266', 23, NULL, 'centOS7下安装GUI图形界面', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (125, '2019-08-27 09:23:55.27', '2019-08-27 09:23:55.27', 23, NULL, 'Aviator 表达式求值引擎开源框架 ', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (126, '2019-08-27 09:23:55.276', '2019-08-27 09:23:55.276', 23, NULL, 'ssm springmvc 配置 spring 定时任务', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (127, '2019-08-27 09:23:55.28', '2019-08-27 09:23:55.28', 23, NULL, 'mybatis 整合 neo4j', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (128, '2019-08-27 09:23:55.284', '2019-08-27 09:23:55.284', 23, NULL, 'win10远程桌面身份验证错误,要求的函数不受支持', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (129, '2019-08-27 09:23:55.291', '2019-08-27 09:23:55.291', 23, NULL, 'centos 安装运行tomcat', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (130, '2019-08-27 09:23:55.296', '2019-08-27 09:23:55.296', 23, NULL, 'Spring事务为什么不会自动回滚', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (131, '2019-08-27 09:23:55.303', '2019-08-27 09:23:55.303', 23, NULL, '前后端分离ueditor富文本编辑器的使用-Java版本', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (132, '2019-08-27 09:23:55.318', '2019-08-27 09:23:55.318', 23, NULL, 'centos 安装 elasticsearch', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (133, '2019-08-27 09:23:55.323', '2019-08-27 09:23:55.323', 23, NULL, 'spring 下载问题', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (134, '2019-08-27 09:23:55.332', '2019-08-27 09:23:55.332', 23, NULL, ' 前端 diff 文本 对比', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (135, '2019-08-27 09:23:55.338', '2019-08-27 09:23:55.338', 23, NULL, 'Java8 Map 方法说明', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (136, '2019-08-27 09:23:55.342', '2019-08-27 09:23:55.342', 23, NULL, 'IOS对接心得', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (137, '2019-08-27 09:23:55.347', '2019-08-27 09:23:55.347', 23, NULL, 'spring 中 配置 多线程', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (138, '2019-08-27 09:23:55.35', '2019-08-27 09:23:55.35', 23, NULL, 'Linux查看系统配置常用命令', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (139, '2019-08-27 09:23:55.356', '2019-08-27 09:23:55.356', 23, NULL, 'CentOS7使用firewalld打开关闭防火墙与端口', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (140, '2019-08-27 09:23:55.361', '2019-08-27 09:23:55.361', 23, NULL, 'linux服务器测试网速', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (141, '2019-08-27 09:23:55.364', '2019-08-27 09:23:55.364', 23, NULL, 'springboot监控和管理控制台', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (142, '2019-08-27 09:23:55.369', '2019-08-27 09:23:55.369', 23, NULL, 'Mybatis使用经验', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (143, '2019-08-27 09:23:55.374', '2019-08-27 09:23:55.374', 23, NULL, 'lambda表达式的实际应用', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (144, '2019-08-27 09:23:55.382', '2019-08-27 09:23:55.382', 23, NULL, 'MySql数据库时区问题', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (145, '2019-08-27 09:23:55.387', '2019-08-27 09:23:55.387', 23, NULL, 'Elasticsearch常见操作于问题', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (146, '2019-08-27 09:23:55.392', '2019-08-27 09:23:55.392', 23, NULL, '学习ElasticSearch', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (147, '2019-08-27 09:23:55.428', '2019-08-27 09:23:55.428', 23, NULL, 'Centos7 搭建kafka服务器', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (148, '2019-08-27 09:23:55.433', '2019-08-27 09:23:55.433', 23, NULL, '优秀的sql', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (149, '2019-08-27 09:23:55.437', '2019-08-27 09:23:55.437', 23, NULL, '微信小程序之微信授权讲解', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (150, '2019-08-27 09:23:55.443', '2019-08-27 09:23:55.443', 23, NULL, 'Java8特性详解 lambda表达式 Stream', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (151, '2019-08-27 09:23:55.454', '2019-08-27 09:23:55.454', 23, NULL, 'Window 中杀死指定端口 cmd 命令行 taskkill', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (152, '2019-08-27 09:23:55.458', '2019-08-27 09:23:55.458', 23, NULL, 'springboot条件化注解', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (153, '2019-08-27 09:23:55.461', '2019-08-27 09:23:55.461', 23, NULL, 'Centos7安装JDK', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (154, '2019-08-27 09:23:55.465', '2019-08-27 09:23:55.465', 23, NULL, '阿里云Https部署网站', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (155, '2019-08-27 09:23:55.471', '2019-08-27 09:23:55.471', 23, NULL, '使用wsimport命令生成webService客户端代码实例', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (156, '2019-08-27 09:23:55.476', '2019-08-27 09:23:55.476', 23, NULL, '微信小程序使用wxParse解析html', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (157, '2019-08-27 09:23:55.48', '2019-08-27 09:23:55.48', 23, NULL, '微信小程序前后端交互流程', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (158, '2019-08-27 09:23:55.486', '2019-08-27 09:23:55.486', 23, NULL, '数据库批量新增修改', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (159, '2019-08-27 09:23:55.49', '2019-08-27 09:23:55.49', 23, NULL, '503 Service Temporarily Unavailable', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (160, '2019-08-27 09:23:55.497', '2019-08-27 09:23:55.497', 23, NULL, '浅谈js在html中的加载执行顺序,多个jquery ready执行顺序', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (161, '2019-08-27 09:23:55.505', '2019-08-27 09:23:55.505', 23, NULL, '后台Http请求接口GET与POST方式', 'ShowLu', 1, '0', 0, 0, 1, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (162, NULL, NULL, 1, NULL, 'title', 'showlu', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (163, NULL, NULL, 1, NULL, 'title', 'showlu', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `lu_article` (`id`, `create_time`, `update_time`, `header_pid`, `user_id`, `title`, `author`, `auth_level`, `points`, `views`, `thumbs_up`, `status`, `sort`) VALUES (164, NULL, NULL, 1, NULL, 'title', 'showlu', NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `pid` bigint(20) DEFAULT '0' COMMENT '父部门id',
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
  `sort` int(4) DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
  `status` smallint(6) DEFAULT '1' COMMENT '部门状态（0停用 1正常）',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建者',
  `update_user_id` bigint(20) NOT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_message_queue_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_message_queue_config`;
CREATE TABLE `sys_message_queue_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `topic` varchar(50) NOT NULL COMMENT '主题',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态 0禁用;1启用',
  `class_name` varchar(255) NOT NULL COMMENT '处理类',
  `method_name` varchar(50) NOT NULL COMMENT '处理方法',
  `create_by` varchar(50) NOT NULL COMMENT '创建人',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='系统消息队列配置';

-- ----------------------------
-- Records of sys_message_queue_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_message_queue_config` (`id`, `topic`, `status`, `class_name`, `method_name`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (1, 'lu-db-test', 1, 'com.lu.stack.nacos.feign.FeignToArticle', 't6', 'lu', NULL, '2023-02-14 13:18:58', NULL);
INSERT INTO `sys_message_queue_config` (`id`, `topic`, `status`, `class_name`, `method_name`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (5, 'lu-db-test-topic-1', 1, 'com.lu.stack.message.center.service.DbMessageQueueService', 't6', 'lu', NULL, '2023-02-14 17:30:18', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_message_queue_logs
-- ----------------------------
DROP TABLE IF EXISTS `sys_message_queue_logs`;
CREATE TABLE `sys_message_queue_logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `config_id` bigint(20) NOT NULL COMMENT 'sys_message_queue_config表id',
  `status` tinyint(4) DEFAULT '0' COMMENT '状态 0待执行;1执行中;2执行成功;-1执行失败',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `start_execute_time` datetime DEFAULT NULL COMMENT '执行开始时间',
  `end_execute_time` datetime DEFAULT NULL COMMENT '执行结束时间',
  `message` text NOT NULL COMMENT '消息',
  `execute_result` text COMMENT '执行结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='系统消息队列日志';

-- ----------------------------
-- Records of sys_message_queue_logs
-- ----------------------------
BEGIN;
INSERT INTO `sys_message_queue_logs` (`id`, `config_id`, `status`, `create_time`, `start_execute_time`, `end_execute_time`, `message`, `execute_result`) VALUES (1, 1, 2, '2023-02-14 13:19:51', '2023-02-14 07:51:15', '2023-02-14 07:57:59', '{\"k1\":\"v1\",\"k2\":1,\"k3\":true}', 'ok');
INSERT INTO `sys_message_queue_logs` (`id`, `config_id`, `status`, `create_time`, `start_execute_time`, `end_execute_time`, `message`, `execute_result`) VALUES (8, 1, 1, '2023-02-14 16:16:48', '2023-02-14 16:16:50', NULL, '{\"k1\":\"v1\",\"k2\":1,\"k3\":true}', 'waitConsume');
INSERT INTO `sys_message_queue_logs` (`id`, `config_id`, `status`, `create_time`, `start_execute_time`, `end_execute_time`, `message`, `execute_result`) VALUES (9, 5, 1, '2023-02-14 17:30:18', '2023-02-14 17:30:27', NULL, '{\"name\":\"zjc\",\"sex\":\"男\"，\"age\":26}', 'waitConsume');
COMMIT;

-- ----------------------------
-- Table structure for sys_resources
-- ----------------------------
DROP TABLE IF EXISTS `sys_resources`;
CREATE TABLE `sys_resources` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `pid` bigint(20) DEFAULT '0' COMMENT '父ID',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名',
  `status` smallint(1) DEFAULT '1' COMMENT '状态 1启用 0禁用',
  `sort` int(4) DEFAULT '0' COMMENT '显示顺序',
  `url` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '接口路由地址',
  `type` smallint(1) NOT NULL COMMENT '1 目录菜单 2按钮\n',
  `icon` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图标',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建人\n',
  `update_user_id` bigint(20) NOT NULL COMMENT '更新人\n\n',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `sys_resources_url_uindex` (`url`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8 COMMENT='资源表';

-- ----------------------------
-- Records of sys_resources
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
  `sort` int(4) DEFAULT '0' COMMENT '显示顺序',
  `status` smallint(1) DEFAULT '1' COMMENT '角色状态（0停用 1正常）',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建者',
  `update_user_id` bigint(20) NOT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `description` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8 COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_resources
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_resources`;
CREATE TABLE `sys_role_resources` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录编号',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `resource_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `update_user_id` bigint(20) NOT NULL COMMENT '维护者\n\n',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间\n',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sys_role_resources_resource_id_index` (`resource_id`) USING BTREE,
  KEY `sys_role_resources_role_id_index` (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4915 DEFAULT CHARSET=utf8 COMMENT='后台管理角色-菜单表';

-- ----------------------------
-- Records of sys_role_resources
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `real_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '真实姓名\n',
  `gender` smallint(1) DEFAULT NULL COMMENT '性别(0男 1女)',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号码',
  `email` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
  `company` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司',
  `attachment` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '附件',
  `status` smallint(1) DEFAULT '1' COMMENT '状态（0停用 1正常）',
  `avatar` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '个人照片',
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '家庭地址',
  `description` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '个人简介',
  `position` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '公司职务',
  `login_ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最后登录IP',
  `login_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后登录时间',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建者',
  `update_user_id` bigint(20) NOT NULL COMMENT '更新者',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `sys_user_username_uindex` (`username`) USING BTREE,
  UNIQUE KEY `sys_user_phone_uindex` (`phone`) USING BTREE,
  KEY `sys_user_dept_id_index` (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1250 DEFAULT CHARSET=utf8 COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录编号',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `update_user_id` bigint(20) NOT NULL COMMENT '创建人',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `sys_user_role_role_id_index` (`role_id`) USING BTREE,
  KEY `sys_user_role_user_id_index` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
